package com.jd.ty.dao.constant;

public class QueryConstants {
	
	public static final String LT = "<";
	public static final String LE = "<=";
	public static final String GT = ">";
	public static final String GE = ">=";
	public static final String EQ = "=";
	public static final String NE = "!=";
	public static final String LIKE = "like";

	public static final String DESC = "DESC";
	public static final String ASC = "ASC";
	
	

	


	public static final class Function {
		public static final String FUNCTION_ID = "functionId";
		public static final String FUNCTION_NAME = "functionName";
		public static final String PARENT = "parent";
	}

	public static final class Permission {
		public static final String PERMISSION_ID = "permissionId";
		public static final String ROLE = "role";
		public static final String FUNCTION = "function";
		public static final String PERMISSION = "permission";
	}

	public static final class User {
		public static final String userId = "userId";
		public static final String loginId = "loginId";
		public static final String ROLE = "role";
		}
	public static final class Role {
		public static final String ROLE_NAME = "roleName";
		public static final String IS_ADMIN = "isAdmin";
		public static final String ROLE_ID = "roleId";
	}
	public static final class Dictionary {
		public static final String DICTIONARY_ID = "dictionaryId";
		public static final String DICTIONARY_NAME = "dictionaryName";
		public static final String CODE = "code";
		public static final String DESCRIPTION = "description";
		public static final String PARENT= "parentDictionary";
	}
	public static final class Employee {
		public static final String EMPLOYEE_ID = "employeeId";
		public static final String EMPLOYEE_NAME = "employeeName";
		public static final String DEPARMENT = "department";
		public static final String POSITION = "position";
	}

	public static final class Customer {
		public static final String CUST_COMPANY = "custCompany";
		public static final String CUSTOMER_ID = "customerId";
		public static final String CUSTOMER_NAME = "customerName";
		public static final String PHONE_NUMBER = "phoneNumber";
		public static final String POSITION = "position";
		public static final String SEX = "sex";
	}
	
	public static final class Order {
		public static final String COMPANY = "customerCompany";
		public static final String CUSTOMER = "customer";
		public static final String DEAL_DATE = "dealDate";
		public static final String PROJECT_TYPE="projectType";

	}
	public static final class CustomerCompany {
		public static final String ADDRESS = "address";
		public static final String CUST_COMPANY_ID = "custCompanyId";
		public static final String CUST_COMPANY_NAME = "custCompanyName";
		public static final String CUSTOMERS = "customers";
		public static final String FAX_NUMBER = "faxNumber";
		public static final String PHONE_NUMBER = "phoneNumber";
		public static final String POSTAL_CODE = "postalCode";
		public static final String FIRST_ORDER_TIME = "firstOrderTime";
		public static final String LAST_ORDER_TIME = "lastOrderTime";
	}
	
	public static final class Position {
		public static final String POSITION_ID = "positionId";
		public static final String DEPARMENT = "department";
		public static final String POSITION_NAME = "positionName";
		
	}
	public static final class ProjectAttribute {
		public static final String PROJECT_TYPE = "projectType";
	}
	public static final class AppreciactionLog {
		public static final String COMPANY = "customerCompany";

	}
	
	public static final class Contract{
		public static final String CONTRACT_ID = "contractId";
	}
	
	public static final class BankCard{
		public static final String BANKCARD_ID = "bankCardId";
	}
	
	public static final class Field{
		public static final String REPORT_TYPE="type";
		public static final String FIELD_ID="id";
	}

}
